﻿USE [EntitlementsDatabase]
GO
/****** Object:  Table [dbo].[Products]    Script Date: 10/29/2011 22:20:53 ******/
INSERT [dbo].[Products] ([Id], [Name]) VALUES (N'68499efd-26e2-4f48-aca8-31f134a8cfab', N'Dev_Floating_All')
INSERT [dbo].[Products] ([Id], [Name]) VALUES (N'35b80326-0df9-4a4a-9fec-c87a8c76fb17', N'Dev_Node_Locked')
/****** Object:  Table [dbo].[Nodes]    Script Date: 10/29/2011 22:20:53 ******/
INSERT [dbo].[Nodes] ([Id], [Name]) VALUES (N'20006f9e-7990-419e-ac93-1adcaf5b89f1', N'Devbox')
/****** Object:  Table [dbo].[Customers]    Script Date: 10/29/2011 22:20:53 ******/
INSERT [dbo].[Customers] ([Id], [Name], [Key]) VALUES (N'b4442779-5354-4747-b8c4-86ecc91ce354', N'Dev_Customer', N'1F8A3559BA2F36369AB4A769805A36F3B90BDC31E527FEF830FE87969DDF3ACF1AB098DAF19888389EA6C909000984D5E29FE17858850F12A38B54576249E5660CD78B2FBB9B764B8080CFFDEC0B9955153644D7E820FBA840AC994A327CC4C3D97D2229557EA8FD1A9A23CE09AF786C5A5779EA653B0816F88B9D9B0914ACD3')
INSERT [dbo].[Customers] ([Id], [Name], [Key]) VALUES (N'92c4465d-6a62-44b0-9577-872b2c8cc5f4', N'LicenseServerWebsiteUser', N'3AF7DEAA31E50DC5F31456EDD0176A365B0F06FC93B15C8945263DE92074357E2B8EB97D9A1A9A52EE26A5185FC4C899768A797EFD99E155C30309F76189470E26632460C123F4931C057BC896EDAF79D6ECB8F982EB57FC8FEAF241F514738619926DFFA0BFDCE83088B2356BCB1B1AA9F85795512E5450DBB0C5A3EE46DEE7')
/****** Object:  Table [dbo].[Features]    Script Date: 10/29/2011 22:20:53 ******/
INSERT [dbo].[Features] ([Id], [Name]) VALUES (N'd8c8928a-0e5c-4388-991b-2d3e2de7a117', N'Dev_Counted_Floating_Executions_1')
INSERT [dbo].[Features] ([Id], [Name]) VALUES (N'8308b3ab-f4b9-4f36-bf7b-3f5aced48675', N'Dev_Counted_Floating_Concurrent_1000')
INSERT [dbo].[Features] ([Id], [Name]) VALUES (N'2d71f723-c556-4415-bcdf-4a471832d003', N'Dev_Counted_Floating_Executions_1000000000')
INSERT [dbo].[Features] ([Id], [Name]) VALUES (N'b7a715fe-389b-4863-b83b-aa81546d9f7a', N'Dev_Uncounted_Floating')
INSERT [dbo].[Features] ([Id], [Name]) VALUES (N'4a2367bf-1ca7-4e5b-8f2c-d78d92f5dcf1', N'Dev_Node_Locked')
INSERT [dbo].[Features] ([Id], [Name]) VALUES (N'a8890a44-2988-496c-ba7e-df3dcf4cc373', N'Dev_Counted_Floating_Concurrent_1')
/****** Object:  Table [dbo].[Identifiers]    Script Date: 10/29/2011 22:20:53 ******/
INSERT [dbo].[Identifiers] ([Id], [Name], [Value], [Ignore], [Discriminator], [Node_Id]) VALUES (N'b677eac1-4759-4188-8c90-165399be8db2', N'BiosSerialNumber', N'BD9DVQ1', 1, N'BiosIdentifier', N'20006f9e-7990-419e-ac93-1adcaf5b89f1')
INSERT [dbo].[Identifiers] ([Id], [Name], [Value], [Ignore], [Discriminator], [Node_Id]) VALUES (N'8060a133-c6b0-46af-969d-7e9465a3c0b7', N'MacAddress', N'00:FF:B0:6B:A9:0B', 1, N'MacAddressIdentifier', N'20006f9e-7990-419e-ac93-1adcaf5b89f1')
INSERT [dbo].[Identifiers] ([Id], [Name], [Value], [Ignore], [Discriminator], [Node_Id]) VALUES (N'cee38705-0232-4ea4-87c1-90048a4eb2e7', N'MacAddress', N'5C:26:0A:5C:86:61', 1, N'MacAddressIdentifier', N'20006f9e-7990-419e-ac93-1adcaf5b89f1')
INSERT [dbo].[Identifiers] ([Id], [Name], [Value], [Ignore], [Discriminator], [Node_Id]) VALUES (N'4084e688-f432-4038-8d3e-991d9d3b69e3', N'ProcessorId', N'BFEBFBFF000206A7', 1, N'ProcessorIdentifier', N'20006f9e-7990-419e-ac93-1adcaf5b89f1')
INSERT [dbo].[Identifiers] ([Id], [Name], [Value], [Ignore], [Discriminator], [Node_Id]) VALUES (N'2c661775-937b-4ff3-8089-bb20f5fcb3b2', N'MacAddress', N'00:24:D7:98:3C:A8', 1, N'MacAddressIdentifier', N'20006f9e-7990-419e-ac93-1adcaf5b89f1')
INSERT [dbo].[Identifiers] ([Id], [Name], [Value], [Ignore], [Discriminator], [Node_Id]) VALUES (N'81337654-48f9-4ef0-9287-ddefcb431c10', N'MacAddress', N'20:41:53:59:4E:FF', 1, N'MacAddressIdentifier', N'20006f9e-7990-419e-ac93-1adcaf5b89f1')
INSERT [dbo].[Identifiers] ([Id], [Name], [Value], [Ignore], [Discriminator], [Node_Id]) VALUES (N'c218a857-18be-43d3-978f-eef105fb5990', N'MacAddress', N'D0:DF:9A:3C:71:B2', 1, N'MacAddressIdentifier', N'20006f9e-7990-419e-ac93-1adcaf5b89f1')
/****** Object:  Table [dbo].[FeatureProducts]    Script Date: 10/29/2011 22:20:53 ******/
INSERT [dbo].[FeatureProducts] ([Feature_Id], [Product_Id]) VALUES (N'd8c8928a-0e5c-4388-991b-2d3e2de7a117', N'68499efd-26e2-4f48-aca8-31f134a8cfab')
INSERT [dbo].[FeatureProducts] ([Feature_Id], [Product_Id]) VALUES (N'8308b3ab-f4b9-4f36-bf7b-3f5aced48675', N'68499efd-26e2-4f48-aca8-31f134a8cfab')
INSERT [dbo].[FeatureProducts] ([Feature_Id], [Product_Id]) VALUES (N'2d71f723-c556-4415-bcdf-4a471832d003', N'68499efd-26e2-4f48-aca8-31f134a8cfab')
INSERT [dbo].[FeatureProducts] ([Feature_Id], [Product_Id]) VALUES (N'b7a715fe-389b-4863-b83b-aa81546d9f7a', N'68499efd-26e2-4f48-aca8-31f134a8cfab')
INSERT [dbo].[FeatureProducts] ([Feature_Id], [Product_Id]) VALUES (N'4a2367bf-1ca7-4e5b-8f2c-d78d92f5dcf1', N'35b80326-0df9-4a4a-9fec-c87a8c76fb17')
INSERT [dbo].[FeatureProducts] ([Feature_Id], [Product_Id]) VALUES (N'a8890a44-2988-496c-ba7e-df3dcf4cc373', N'68499efd-26e2-4f48-aca8-31f134a8cfab')
/****** Object:  Table [dbo].[CustomerEntitlements]    Script Date: 10/29/2011 22:20:53 ******/
INSERT [dbo].[CustomerEntitlements] ([Id], [Customer_Id]) VALUES (N'a4e62ffb-614c-4043-a858-87f74fdad851', N'92c4465d-6a62-44b0-9577-872b2c8cc5f4')
INSERT [dbo].[CustomerEntitlements] ([Id], [Customer_Id]) VALUES (N'017c3852-e786-46d7-a6f2-aeb45b0ab138', N'b4442779-5354-4747-b8c4-86ecc91ce354')
/****** Object:  Table [dbo].[Licenses]    Script Date: 10/29/2011 22:20:53 ******/
INSERT [dbo].[Licenses] ([Id], [Name], [LicenseClientTypeValue], [FloatingLicenseLimitTypeValue], [Limit], [Discriminator], [Feature_Id]) VALUES (N'0718d0a9-a94b-440d-bef2-008140720732', N'Dev_Counted_Floating_Concurrent_1000_License', N'Checkout', N'Concurrency', 1000, N'CountedFloatingLicense', N'8308b3ab-f4b9-4f36-bf7b-3f5aced48675')
INSERT [dbo].[Licenses] ([Id], [Name], [LicenseClientTypeValue], [FloatingLicenseLimitTypeValue], [Limit], [Discriminator], [Feature_Id]) VALUES (N'f2f00146-4255-426e-8226-0a3c4e542c28', N'Dev_Counted_Floating_Executions_1000000000_License', N'Checkout', N'Execution', 1000000000, N'CountedFloatingLicense', N'2d71f723-c556-4415-bcdf-4a471832d003')
INSERT [dbo].[Licenses] ([Id], [Name], [LicenseClientTypeValue], [FloatingLicenseLimitTypeValue], [Limit], [Discriminator], [Feature_Id]) VALUES (N'5e661499-a8e7-497a-a41d-3f63e8ac586a', N'Dev_Uncounted_Floating_License', N'Checkout', NULL, NULL, N'UncountedFloatingLicense', N'b7a715fe-389b-4863-b83b-aa81546d9f7a')
INSERT [dbo].[Licenses] ([Id], [Name], [LicenseClientTypeValue], [FloatingLicenseLimitTypeValue], [Limit], [Discriminator], [Feature_Id]) VALUES (N'e09be582-5212-433e-a2e1-4701190b7c42', N'Dev_Node_Locked_License', NULL, NULL, NULL, N'NodeLockedLicense', N'4a2367bf-1ca7-4e5b-8f2c-d78d92f5dcf1')
INSERT [dbo].[Licenses] ([Id], [Name], [LicenseClientTypeValue], [FloatingLicenseLimitTypeValue], [Limit], [Discriminator], [Feature_Id]) VALUES (N'5d1b8c22-773c-4c23-8697-87a9db2cc558', N'Dev_Counted_Floating_Concurrent_1_License', N'Checkout', N'Concurrency', 1, N'CountedFloatingLicense', N'a8890a44-2988-496c-ba7e-df3dcf4cc373')
INSERT [dbo].[Licenses] ([Id], [Name], [LicenseClientTypeValue], [FloatingLicenseLimitTypeValue], [Limit], [Discriminator], [Feature_Id]) VALUES (N'43df5e76-1163-46a7-990f-e7c4d78372f4', N'Dev_Counted_Floating_Executions_1_License', N'Checkout', N'Execution', 1, N'CountedFloatingLicense', N'd8c8928a-0e5c-4388-991b-2d3e2de7a117')
/****** Object:  Table [dbo].[LicenseEntitlements]    Script Date: 10/29/2011 22:20:53 ******/
INSERT [dbo].[LicenseEntitlements] ([Id], [CreatedOn], [ValidFrom], [ValidTo], [License_Id], [Node_Id], [Product_Id], [CustomerEntitlement_Id]) VALUES (N'a9890dbd-2596-49e5-88a8-6947ea93080e', CAST(0x00009F8B011291D1 AS DateTime), NULL, NULL, N'e09be582-5212-433e-a2e1-4701190b7c42', N'20006f9e-7990-419e-ac93-1adcaf5b89f1', N'35b80326-0df9-4a4a-9fec-c87a8c76fb17', N'017c3852-e786-46d7-a6f2-aeb45b0ab138')
INSERT [dbo].[LicenseEntitlements] ([Id], [CreatedOn], [ValidFrom], [ValidTo], [License_Id], [Node_Id], [Product_Id], [CustomerEntitlement_Id]) VALUES (N'f0f9f928-8224-4644-ba1b-74e3b8b76fc7', CAST(0x00009F740108166A AS DateTime), NULL, NULL, N'f2f00146-4255-426e-8226-0a3c4e542c28', N'20006f9e-7990-419e-ac93-1adcaf5b89f1', N'68499efd-26e2-4f48-aca8-31f134a8cfab', N'017c3852-e786-46d7-a6f2-aeb45b0ab138')
INSERT [dbo].[LicenseEntitlements] ([Id], [CreatedOn], [ValidFrom], [ValidTo], [License_Id], [Node_Id], [Product_Id], [CustomerEntitlement_Id]) VALUES (N'964741d3-e1f5-4d60-adae-b441b22b0d2b', CAST(0x00009F7401080783 AS DateTime), NULL, NULL, N'43df5e76-1163-46a7-990f-e7c4d78372f4', N'20006f9e-7990-419e-ac93-1adcaf5b89f1', N'68499efd-26e2-4f48-aca8-31f134a8cfab', N'017c3852-e786-46d7-a6f2-aeb45b0ab138')
INSERT [dbo].[LicenseEntitlements] ([Id], [CreatedOn], [ValidFrom], [ValidTo], [License_Id], [Node_Id], [Product_Id], [CustomerEntitlement_Id]) VALUES (N'0e823766-a0a6-4bf1-888f-c12837fd8f85', CAST(0x00009F7401082BA9 AS DateTime), NULL, NULL, N'5e661499-a8e7-497a-a41d-3f63e8ac586a', N'20006f9e-7990-419e-ac93-1adcaf5b89f1', N'68499efd-26e2-4f48-aca8-31f134a8cfab', N'017c3852-e786-46d7-a6f2-aeb45b0ab138')
INSERT [dbo].[LicenseEntitlements] ([Id], [CreatedOn], [ValidFrom], [ValidTo], [License_Id], [Node_Id], [Product_Id], [CustomerEntitlement_Id]) VALUES (N'2b243a15-4d51-483d-bd8c-cfe63fc8cb68', CAST(0x00009F740107F78B AS DateTime), NULL, NULL, N'0718d0a9-a94b-440d-bef2-008140720732', N'20006f9e-7990-419e-ac93-1adcaf5b89f1', N'68499efd-26e2-4f48-aca8-31f134a8cfab', N'017c3852-e786-46d7-a6f2-aeb45b0ab138')
INSERT [dbo].[LicenseEntitlements] ([Id], [CreatedOn], [ValidFrom], [ValidTo], [License_Id], [Node_Id], [Product_Id], [CustomerEntitlement_Id]) VALUES (N'621504c2-86c1-46e4-bbb1-e6d7a465eaea', CAST(0x00009F740107D6D7 AS DateTime), NULL, NULL, N'5d1b8c22-773c-4c23-8697-87a9db2cc558', N'20006f9e-7990-419e-ac93-1adcaf5b89f1', N'68499efd-26e2-4f48-aca8-31f134a8cfab', N'017c3852-e786-46d7-a6f2-aeb45b0ab138')
